Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 197428 |
| Missing cells | 56061 |
| Missing cells (%) | 1.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 24.1 MiB |
| Average record size in memory | 128.0 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 3 |
created_at has a high cardinality: 180985 distinct values | High cardinality |
actual_delivery_time has a high cardinality: 178110 distinct values | High cardinality |
store_primary_category has a high cardinality: 74 distinct values | High cardinality |
order_protocol is highly overall correlated with estimated_order_place_duration | High correlation |
total_items is highly overall correlated with subtotal and 2 other fields | High correlation |
subtotal is highly overall correlated with total_items and 2 other fields | High correlation |
num_distinct_items is highly overall correlated with total_items and 2 other fields | High correlation |
min_item_price is highly overall correlated with total_items and 1 other fields | High correlation |
max_item_price is highly overall correlated with subtotal | High correlation |
total_onshift_dashers is highly overall correlated with total_busy_dashers and 1 other fields | High correlation |
total_busy_dashers is highly overall correlated with total_onshift_dashers and 1 other fields | High correlation |
total_outstanding_orders is highly overall correlated with total_onshift_dashers and 1 other fields | High correlation |
estimated_order_place_duration is highly overall correlated with order_protocol | High correlation |
store_primary_category has 4760 (2.4%) missing values | Missing |
total_onshift_dashers has 16262 (8.2%) missing values | Missing |
total_busy_dashers has 16262 (8.2%) missing values | Missing |
total_outstanding_orders has 16262 (8.2%) missing values | Missing |
total_items is highly skewed (γ1 = 21.41382417) | Skewed |
created_at is uniformly distributed | Uniform |
actual_delivery_time is uniformly distributed | Uniform |
min_item_price has 2539 (1.3%) zeros | Zeros |
total_onshift_dashers has 3615 (1.8%) zeros | Zeros |
total_busy_dashers has 4171 (2.1%) zeros | Zeros |
total_outstanding_orders has 4111 (2.1%) zeros | Zeros |
Reproduction
| Analysis started | 2022-12-28 08:23:16.579813 |
|---|---|
| Analysis finished | 2022-12-28 08:24:01.124950 |
| Duration | 44.55 seconds |
| Software version | pandas-profiling vv3.6.1 |
| Download configuration | config.json |
market_id
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 987 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9787061 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.5248667 |
|---|---|
| Coefficient of variation (CV) | 0.51192252 |
| Kurtosis | -0.93810124 |
| Mean | 2.9787061 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.36120013 |
| Sum | 585140 |
| Variance | 2.3252185 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 55058 | |
| 4 | 47599 | |
| 1 | 38037 | |
| 3 | 23297 | |
| 5 | 18000 | 9.1% |
| 6 | 14450 | 7.3% |
| (Missing) | 987 | 0.5% |
| Value | Count | Frequency (%) |
| 1 | 38037 | |
| 2 | 55058 | |
| 3 | 23297 | |
| 4 | 47599 | |
| 5 | 18000 | 9.1% |
| 6 | 14450 | 7.3% |
| Value | Count | Frequency (%) |
| 6 | 14450 | 7.3% |
| 5 | 18000 | 9.1% |
| 4 | 47599 | |
| 3 | 23297 | |
| 2 | 55058 | |
| 1 | 38037 |
created_at
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 180985 |
|---|---|
| Distinct (%) | 91.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.5 MiB |
| 2015-02-11 19:50:43 | 6 |
|---|---|
| 2015-01-24 01:56:33 | 6 |
| 2015-02-16 01:48:11 | 5 |
| 2015-02-08 02:20:03 | 5 |
| 2015-02-11 19:51:06 | 5 |
| Other values (180980) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 3751132 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 165374 ? |
|---|---|
| Unique (%) | 83.8% |
Sample
| 1st row | 2015-02-06 22:24:17 |
|---|---|
| 2nd row | 2015-02-10 21:49:25 |
| 3rd row | 2015-01-22 20:39:28 |
| 4th row | 2015-02-03 21:21:45 |
| 5th row | 2015-02-15 02:40:36 |
Common Values
| Value | Count | Frequency (%) |
| 2015-02-11 19:50:43 | 6 | < 0.1% |
| 2015-01-24 01:56:33 | 6 | < 0.1% |
| 2015-02-16 01:48:11 | 5 | < 0.1% |
| 2015-02-08 02:20:03 | 5 | < 0.1% |
| 2015-02-11 19:51:06 | 5 | < 0.1% |
| 2015-02-11 19:50:41 | 5 | < 0.1% |
| 2015-01-31 01:41:10 | 5 | < 0.1% |
| 2015-01-31 02:16:03 | 4 | < 0.1% |
| 2015-02-16 01:47:34 | 4 | < 0.1% |
| 2015-02-03 02:04:13 | 4 | < 0.1% |
| Other values (180975) | 197379 |
Length
| Value | Count | Frequency (%) |
| 2015-02-07 | 9149 | 2.3% |
| 2015-02-15 | 9087 | 2.3% |
| 2015-02-14 | 9016 | 2.3% |
| 2015-02-08 | 8874 | 2.2% |
| 2015-01-24 | 8230 | 2.1% |
| 2015-01-31 | 8146 | 2.1% |
| 2015-01-25 | 7934 | 2.0% |
| 2015-02-16 | 7932 | 2.0% |
| 2015-02-01 | 7724 | 2.0% |
| 2015-02-13 | 7383 | 1.9% |
| Other values (46097) | 311381 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 733984 | |
| 2 | 595423 | |
| 1 | 523163 | |
| - | 394856 | |
| : | 394856 | |
| 5 | 334468 | |
| 197428 | 5.3% | |
| 3 | 175161 | 4.7% |
| 4 | 144084 | 3.8% |
| 9 | 66680 | 1.8% |
| Other values (3) | 191029 | 5.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2763992 | |
| Dash Punctuation | 394856 | 10.5% |
| Other Punctuation | 394856 | 10.5% |
| Space Separator | 197428 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 733984 | |
| 2 | 595423 | |
| 1 | 523163 | |
| 5 | 334468 | |
| 3 | 175161 | 6.3% |
| 4 | 144084 | 5.2% |
| 9 | 66680 | 2.4% |
| 7 | 64293 | 2.3% |
| 6 | 63494 | 2.3% |
| 8 | 63242 | 2.3% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 394856 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 394856 |
Space Separator
| Value | Count | Frequency (%) |
| 197428 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3751132 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 733984 | |
| 2 | 595423 | |
| 1 | 523163 | |
| - | 394856 | |
| : | 394856 | |
| 5 | 334468 | |
| 197428 | 5.3% | |
| 3 | 175161 | 4.7% |
| 4 | 144084 | 3.8% |
| 9 | 66680 | 1.8% |
| Other values (3) | 191029 | 5.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3751132 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 733984 | |
| 2 | 595423 | |
| 1 | 523163 | |
| - | 394856 | |
| : | 394856 | |
| 5 | 334468 | |
| 197428 | 5.3% | |
| 3 | 175161 | 4.7% |
| 4 | 144084 | 3.8% |
| 9 | 66680 | 1.8% |
| Other values (3) | 191029 | 5.1% |
actual_delivery_time
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 178110 |
|---|---|
| Distinct (%) | 90.2% |
| Missing | 7 |
| Missing (%) | < 0.1% |
| Memory size | 1.5 MiB |
| 2015-02-11 20:40:45 | 5 |
|---|---|
| 2015-02-16 03:51:49 | 5 |
| 2015-02-01 03:44:13 | 5 |
| 2015-01-24 03:41:03 | 5 |
| 2015-02-12 03:14:14 | 5 |
| Other values (178105) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 3750999 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 160456 ? |
|---|---|
| Unique (%) | 81.3% |
Sample
| 1st row | 2015-02-06 23:27:16 |
|---|---|
| 2nd row | 2015-02-10 22:56:29 |
| 3rd row | 2015-01-22 21:09:09 |
| 4th row | 2015-02-03 22:13:00 |
| 5th row | 2015-02-15 03:20:26 |
Common Values
| Value | Count | Frequency (%) |
| 2015-02-11 20:40:45 | 5 | < 0.1% |
| 2015-02-16 03:51:49 | 5 | < 0.1% |
| 2015-02-01 03:44:13 | 5 | < 0.1% |
| 2015-01-24 03:41:03 | 5 | < 0.1% |
| 2015-02-12 03:14:14 | 5 | < 0.1% |
| 2015-02-05 03:10:31 | 5 | < 0.1% |
| 2015-02-08 04:09:25 | 5 | < 0.1% |
| 2015-02-14 03:21:32 | 4 | < 0.1% |
| 2015-02-06 03:04:54 | 4 | < 0.1% |
| 2015-02-11 03:28:30 | 4 | < 0.1% |
| Other values (178100) | 197374 | |
| (Missing) | 7 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| 2015-02-07 | 9079 | 2.3% |
| 2015-02-15 | 9011 | 2.3% |
| 2015-02-14 | 8916 | 2.3% |
| 2015-02-08 | 8898 | 2.3% |
| 2015-01-24 | 8149 | 2.1% |
| 2015-02-16 | 8147 | 2.1% |
| 2015-01-31 | 8107 | 2.1% |
| 2015-01-25 | 7774 | 2.0% |
| 2015-02-01 | 7651 | 1.9% |
| 2015-02-13 | 7362 | 1.9% |
| Other values (46108) | 311748 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 737718 | |
| 2 | 591865 | |
| 1 | 502637 | |
| - | 394842 | |
| : | 394842 | |
| 5 | 340425 | |
| 197421 | 5.3% | |
| 3 | 183671 | 4.9% |
| 4 | 156275 | 4.2% |
| 6 | 66442 | 1.8% |
| Other values (3) | 184861 | 4.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2763894 | |
| Dash Punctuation | 394842 | 10.5% |
| Other Punctuation | 394842 | 10.5% |
| Space Separator | 197421 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 737718 | |
| 2 | 591865 | |
| 1 | 502637 | |
| 5 | 340425 | |
| 3 | 183671 | 6.6% |
| 4 | 156275 | 5.7% |
| 6 | 66442 | 2.4% |
| 7 | 63787 | 2.3% |
| 8 | 61786 | 2.2% |
| 9 | 59288 | 2.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 394842 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 394842 |
Space Separator
| Value | Count | Frequency (%) |
| 197421 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3750999 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 737718 | |
| 2 | 591865 | |
| 1 | 502637 | |
| - | 394842 | |
| : | 394842 | |
| 5 | 340425 | |
| 197421 | 5.3% | |
| 3 | 183671 | 4.9% |
| 4 | 156275 | 4.2% |
| 6 | 66442 | 1.8% |
| Other values (3) | 184861 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3750999 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 737718 | |
| 2 | 591865 | |
| 1 | 502637 | |
| - | 394842 | |
| : | 394842 | |
| 5 | 340425 | |
| 197421 | 5.3% | |
| 3 | 183671 | 4.9% |
| 4 | 156275 | 4.2% |
| 6 | 66442 | 1.8% |
| Other values (3) | 184861 | 4.9% |
store_id
Real number (ℝ)
| Distinct | 6743 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3530.5103 |
| Minimum | 1 |
|---|---|
| Maximum | 6987 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 375 |
| Q1 | 1686 |
| median | 3592 |
| Q3 | 5299 |
| 95-th percentile | 6709 |
| Maximum | 6987 |
| Range | 6986 |
| Interquartile range (IQR) | 3613 |
Descriptive statistics
| Standard deviation | 2053.4967 |
|---|---|
| Coefficient of variation (CV) | 0.58164304 |
| Kurtosis | -1.2421394 |
| Mean | 3530.5103 |
| Median Absolute Deviation (MAD) | 1813 |
| Skewness | -0.0068077416 |
| Sum | 6.9702158 × 108 |
| Variance | 4216848.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6865 | 937 | 0.5% |
| 1311 | 863 | 0.4% |
| 314 | 815 | 0.4% |
| 1686 | 765 | 0.4% |
| 3937 | 721 | 0.4% |
| 6917 | 668 | 0.3% |
| 6074 | 632 | 0.3% |
| 4367 | 593 | 0.3% |
| 3748 | 560 | 0.3% |
| 6503 | 548 | 0.3% |
| Other values (6733) | 190326 |
| Value | Count | Frequency (%) |
| 1 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 136 | |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 19 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 12 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 6987 | 2 | < 0.1% |
| 6986 | 39 | |
| 6985 | 2 | < 0.1% |
| 6984 | 4 | < 0.1% |
| 6983 | 24 | |
| 6982 | 18 | |
| 6981 | 25 | |
| 6980 | 5 | < 0.1% |
| 6979 | 5 | < 0.1% |
| 6977 | 39 |
store_primary_category
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 74 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4760 |
| Missing (%) | 2.4% |
| Memory size | 1.5 MiB |
| american | |
|---|---|
| pizza | |
| mexican | |
| burger | 10958 |
| sandwich | 10060 |
| Other values (69) |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 6.9550989 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1340025 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | american |
|---|---|
| 2nd row | mexican |
| 3rd row | indian |
| 4th row | italian |
| 5th row | italian |
Common Values
| Value | Count | Frequency (%) |
| american | 19399 | 9.8% |
| pizza | 17321 | 8.8% |
| mexican | 17099 | 8.7% |
| burger | 10958 | 5.6% |
| sandwich | 10060 | 5.1% |
| chinese | 9421 | 4.8% |
| japanese | 9196 | 4.7% |
| dessert | 8773 | 4.4% |
| fast | 7372 | 3.7% |
| indian | 7314 | 3.7% |
| Other values (64) | 75755 |
Length
| Value | Count | Frequency (%) |
| american | 19399 | 10.1% |
| pizza | 17321 | 9.0% |
| mexican | 17099 | 8.9% |
| burger | 10958 | 5.7% |
| sandwich | 10060 | 5.2% |
| chinese | 9421 | 4.9% |
| japanese | 9196 | 4.8% |
| dessert | 8773 | 4.6% |
| fast | 7372 | 3.8% |
| indian | 7314 | 3.8% |
| Other values (64) | 75755 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 208055 | |
| e | 184292 | |
| i | 140842 | |
| n | 120198 | |
| s | 87943 | 6.6% |
| r | 87208 | 6.5% |
| c | 66888 | 5.0% |
| t | 61611 | 4.6% |
| m | 55053 | 4.1% |
| d | 42279 | 3.2% |
| Other values (16) | 285656 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1335933 | |
| Dash Punctuation | 4092 | 0.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 208055 | |
| e | 184292 | |
| i | 140842 | |
| n | 120198 | |
| s | 87943 | 6.6% |
| r | 87208 | 6.5% |
| c | 66888 | 5.0% |
| t | 61611 | 4.6% |
| m | 55053 | 4.1% |
| d | 42279 | 3.2% |
| Other values (15) | 281564 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4092 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1335933 | |
| Common | 4092 | 0.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 208055 | |
| e | 184292 | |
| i | 140842 | |
| n | 120198 | |
| s | 87943 | 6.6% |
| r | 87208 | 6.5% |
| c | 66888 | 5.0% |
| t | 61611 | 4.6% |
| m | 55053 | 4.1% |
| d | 42279 | 3.2% |
| Other values (15) | 281564 |
Common
| Value | Count | Frequency (%) |
| - | 4092 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1340025 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 208055 | |
| e | 184292 | |
| i | 140842 | |
| n | 120198 | |
| s | 87943 | 6.6% |
| r | 87208 | 6.5% |
| c | 66888 | 5.0% |
| t | 61611 | 4.6% |
| m | 55053 | 4.1% |
| d | 42279 | 3.2% |
| Other values (16) | 285656 |
order_protocol
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 995 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.8823517 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.5037712 |
|---|---|
| Coefficient of variation (CV) | 0.52171676 |
| Kurtosis | -1.3045907 |
| Mean | 2.8823517 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.13709259 |
| Sum | 566189 |
| Variance | 2.2613278 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 54725 | |
| 3 | 53199 | |
| 5 | 44290 | |
| 2 | 24052 | |
| 4 | 19354 | 9.8% |
| 6 | 794 | 0.4% |
| 7 | 19 | < 0.1% |
| (Missing) | 995 | 0.5% |
| Value | Count | Frequency (%) |
| 1 | 54725 | |
| 2 | 24052 | |
| 3 | 53199 | |
| 4 | 19354 | 9.8% |
| 5 | 44290 | |
| 6 | 794 | 0.4% |
| 7 | 19 | < 0.1% |
| Value | Count | Frequency (%) |
| 7 | 19 | < 0.1% |
| 6 | 794 | 0.4% |
| 5 | 44290 | |
| 4 | 19354 | 9.8% |
| 3 | 53199 | |
| 2 | 24052 | |
| 1 | 54725 |
total_items
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 57 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.1963906 |
| Minimum | 1 |
|---|---|
| Maximum | 411 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 7 |
| Maximum | 411 |
| Range | 410 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.6665461 |
|---|---|
| Coefficient of variation (CV) | 0.83423662 |
| Kurtosis | 2801.4213 |
| Mean | 3.1963906 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 21.413824 |
| Sum | 631057 |
| Variance | 7.1104679 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 55134 | |
| 1 | 40619 | |
| 3 | 39253 | |
| 4 | 25138 | |
| 5 | 14055 | 7.1% |
| 6 | 8618 | 4.4% |
| 7 | 5023 | 2.5% |
| 8 | 3050 | 1.5% |
| 9 | 1861 | 0.9% |
| 10 | 1284 | 0.7% |
| Other values (47) | 3393 | 1.7% |
| Value | Count | Frequency (%) |
| 1 | 40619 | |
| 2 | 55134 | |
| 3 | 39253 | |
| 4 | 25138 | |
| 5 | 14055 | 7.1% |
| 6 | 8618 | 4.4% |
| 7 | 5023 | 2.5% |
| 8 | 3050 | 1.5% |
| 9 | 1861 | 0.9% |
| 10 | 1284 | 0.7% |
| Value | Count | Frequency (%) |
| 411 | 1 | |
| 84 | 1 | |
| 66 | 1 | |
| 64 | 1 | |
| 59 | 1 | |
| 57 | 1 | |
| 56 | 1 | |
| 51 | 1 | |
| 50 | 2 | |
| 49 | 2 |
subtotal
Real number (ℝ)
| Distinct | 8368 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2682.3314 |
| Minimum | 0 |
|---|---|
| Maximum | 27100 |
| Zeros | 179 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 805 |
| Q1 | 1400 |
| median | 2200 |
| Q3 | 3395 |
| 95-th percentile | 6200 |
| Maximum | 27100 |
| Range | 27100 |
| Interquartile range (IQR) | 1995 |
Descriptive statistics
| Standard deviation | 1823.0937 |
|---|---|
| Coefficient of variation (CV) | 0.67966758 |
| Kurtosis | 5.9985775 |
| Mean | 2682.3314 |
| Median Absolute Deviation (MAD) | 906 |
| Skewness | 1.9615013 |
| Sum | 5.2956732 × 108 |
| Variance | 3323670.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1500 | 961 | 0.5% |
| 1700 | 913 | 0.5% |
| 2000 | 904 | 0.5% |
| 1200 | 887 | 0.4% |
| 1800 | 883 | 0.4% |
| 1600 | 880 | 0.4% |
| 1095 | 877 | 0.4% |
| 1300 | 871 | 0.4% |
| 2200 | 864 | 0.4% |
| 1400 | 852 | 0.4% |
| Other values (8358) | 188536 |
| Value | Count | Frequency (%) |
| 0 | 179 | |
| 12 | 1 | < 0.1% |
| 95 | 1 | < 0.1% |
| 100 | 1 | < 0.1% |
| 109 | 1 | < 0.1% |
| 125 | 1 | < 0.1% |
| 139 | 1 | < 0.1% |
| 145 | 2 | < 0.1% |
| 149 | 3 | < 0.1% |
| 152 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 27100 | 1 | |
| 26800 | 1 | |
| 24300 | 1 | |
| 22500 | 1 | |
| 20350 | 1 | |
| 19650 | 1 | |
| 19250 | 1 | |
| 18920 | 1 | |
| 18370 | 1 | |
| 17810 | 1 |
num_distinct_items
Real number (ℝ)
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.6707914 |
| Minimum | 1 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.6302552 |
|---|---|
| Coefficient of variation (CV) | 0.61040157 |
| Kurtosis | 4.2696206 |
| Mean | 2.6707914 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.5914791 |
| Sum | 527289 |
| Variance | 2.6577322 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 59174 | |
| 1 | 49839 | |
| 3 | 41843 | |
| 4 | 23185 | 11.7% |
| 5 | 11772 | 6.0% |
| 6 | 5696 | 2.9% |
| 7 | 2917 | 1.5% |
| 8 | 1419 | 0.7% |
| 9 | 734 | 0.4% |
| 10 | 389 | 0.2% |
| Other values (10) | 460 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 49839 | |
| 2 | 59174 | |
| 3 | 41843 | |
| 4 | 23185 | 11.7% |
| 5 | 11772 | 6.0% |
| 6 | 5696 | 2.9% |
| 7 | 2917 | 1.5% |
| 8 | 1419 | 0.7% |
| 9 | 734 | 0.4% |
| 10 | 389 | 0.2% |
| Value | Count | Frequency (%) |
| 20 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 3 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 6 | < 0.1% |
| 15 | 13 | < 0.1% |
| 14 | 35 | < 0.1% |
| 13 | 60 | < 0.1% |
| 12 | 105 | |
| 11 | 233 |
min_item_price
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 2312 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 686.21847 |
| Minimum | -86 |
|---|---|
| Maximum | 14700 |
| Zeros | 2539 |
| Zeros (%) | 1.3% |
| Negative | 13 |
| Negative (%) | < 0.1% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -86 |
|---|---|
| 5-th percentile | 125 |
| Q1 | 299 |
| median | 595 |
| Q3 | 949 |
| 95-th percentile | 1595 |
| Maximum | 14700 |
| Range | 14786 |
| Interquartile range (IQR) | 650 |
Descriptive statistics
| Standard deviation | 522.03865 |
|---|---|
| Coefficient of variation (CV) | 0.76074701 |
| Kurtosis | 14.602635 |
| Mean | 686.21847 |
| Median Absolute Deviation (MAD) | 304 |
| Skewness | 2.3312796 |
| Sum | 1.3547874 × 108 |
| Variance | 272524.35 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 795 | 4197 | 2.1% |
| 250 | 4032 | 2.0% |
| 150 | 3913 | 2.0% |
| 200 | 3863 | 2.0% |
| 350 | 3439 | 1.7% |
| 500 | 3352 | 1.7% |
| 300 | 3317 | 1.7% |
| 600 | 3069 | 1.6% |
| 695 | 3068 | 1.6% |
| 495 | 2852 | 1.4% |
| Other values (2302) | 162326 |
| Value | Count | Frequency (%) |
| -86 | 1 | |
| -52 | 1 | |
| -51 | 1 | |
| -48 | 1 | |
| -35 | 1 | |
| -31 | 1 | |
| -30 | 1 | |
| -13 | 2 | |
| -9 | 1 | |
| -7 | 1 |
| Value | Count | Frequency (%) |
| 14700 | 1 | |
| 8999 | 1 | |
| 8959 | 1 | |
| 8415 | 1 | |
| 7999 | 2 | |
| 7500 | 1 | |
| 7475 | 1 | |
| 7398 | 1 | |
| 7299 | 1 | |
| 7259 | 1 |
max_item_price
Real number (ℝ)
| Distinct | 2652 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1159.5886 |
| Minimum | 0 |
|---|---|
| Maximum | 14700 |
| Zeros | 7 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 439 |
| Q1 | 800 |
| median | 1095 |
| Q3 | 1395 |
| 95-th percentile | 2099 |
| Maximum | 14700 |
| Range | 14700 |
| Interquartile range (IQR) | 595 |
Descriptive statistics
| Standard deviation | 558.41138 |
|---|---|
| Coefficient of variation (CV) | 0.48155989 |
| Kurtosis | 12.915451 |
| Mean | 1159.5886 |
| Median Absolute Deviation (MAD) | 296 |
| Skewness | 2.201033 |
| Sum | 2.2893526 × 108 |
| Variance | 311823.27 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1095 | 5648 | 2.9% |
| 995 | 5057 | 2.6% |
| 1195 | 4349 | 2.2% |
| 1295 | 4214 | 2.1% |
| 999 | 3858 | 2.0% |
| 895 | 3749 | 1.9% |
| 795 | 3606 | 1.8% |
| 799 | 3405 | 1.7% |
| 1200 | 3365 | 1.7% |
| 1395 | 3136 | 1.6% |
| Other values (2642) | 157041 |
| Value | Count | Frequency (%) |
| 0 | 7 | < 0.1% |
| 52 | 1 | < 0.1% |
| 60 | 1 | < 0.1% |
| 75 | 2 | < 0.1% |
| 85 | 1 | < 0.1% |
| 95 | 3 | < 0.1% |
| 99 | 20 | < 0.1% |
| 100 | 22 | |
| 109 | 51 | |
| 110 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 14700 | 1 | < 0.1% |
| 8999 | 1 | < 0.1% |
| 8959 | 1 | < 0.1% |
| 8500 | 1 | < 0.1% |
| 8415 | 1 | < 0.1% |
| 7999 | 3 | |
| 7950 | 1 | < 0.1% |
| 7900 | 1 | < 0.1% |
| 7699 | 2 | |
| 7513 | 1 | < 0.1% |
total_onshift_dashers
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 172 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 16262 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.808093 |
| Minimum | -4 |
|---|---|
| Maximum | 171 |
| Zeros | 3615 |
| Zeros (%) | 1.8% |
| Negative | 21 |
| Negative (%) | < 0.1% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -4 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 17 |
| median | 37 |
| Q3 | 65 |
| 95-th percentile | 115 |
| Maximum | 171 |
| Range | 175 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 34.526783 |
|---|---|
| Coefficient of variation (CV) | 0.77054793 |
| Kurtosis | -0.035222417 |
| Mean | 44.808093 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 0.8607581 |
| Sum | 8117703 |
| Variance | 1192.0988 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3615 | 1.8% |
| 18 | 2924 | 1.5% |
| 15 | 2912 | 1.5% |
| 21 | 2841 | 1.4% |
| 19 | 2824 | 1.4% |
| 10 | 2756 | 1.4% |
| 7 | 2753 | 1.4% |
| 25 | 2752 | 1.4% |
| 9 | 2752 | 1.4% |
| 24 | 2752 | 1.4% |
| Other values (162) | 152285 | |
| (Missing) | 16262 | 8.2% |
| Value | Count | Frequency (%) |
| -4 | 1 | < 0.1% |
| -3 | 1 | < 0.1% |
| -2 | 13 | < 0.1% |
| -1 | 6 | < 0.1% |
| 0 | 3615 | |
| 1 | 950 | 0.5% |
| 2 | 1622 | |
| 3 | 2212 | |
| 4 | 2624 | |
| 5 | 2607 |
| Value | Count | Frequency (%) |
| 171 | 1 | < 0.1% |
| 169 | 1 | < 0.1% |
| 168 | 1 | < 0.1% |
| 165 | 1 | < 0.1% |
| 164 | 1 | < 0.1% |
| 163 | 1 | < 0.1% |
| 162 | 1 | < 0.1% |
| 160 | 9 | |
| 159 | 1 | < 0.1% |
| 158 | 19 |
total_busy_dashers
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 159 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 16262 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.739747 |
| Minimum | -5 |
|---|---|
| Maximum | 154 |
| Zeros | 4171 |
| Zeros (%) | 2.1% |
| Negative | 21 |
| Negative (%) | < 0.1% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -5 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 15 |
| median | 34 |
| Q3 | 62 |
| 95-th percentile | 105 |
| Maximum | 154 |
| Range | 159 |
| Interquartile range (IQR) | 47 |
Descriptive statistics
| Standard deviation | 32.145733 |
|---|---|
| Coefficient of variation (CV) | 0.7701468 |
| Kurtosis | -0.19040114 |
| Mean | 41.739747 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 0.78246259 |
| Sum | 7561823 |
| Variance | 1033.3481 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4171 | 2.1% |
| 10 | 3114 | 1.6% |
| 13 | 3052 | 1.5% |
| 6 | 3040 | 1.5% |
| 18 | 3001 | 1.5% |
| 11 | 2981 | 1.5% |
| 8 | 2977 | 1.5% |
| 12 | 2954 | 1.5% |
| 16 | 2935 | 1.5% |
| 9 | 2934 | 1.5% |
| Other values (149) | 150007 | |
| (Missing) | 16262 | 8.2% |
| Value | Count | Frequency (%) |
| -5 | 1 | < 0.1% |
| -4 | 2 | < 0.1% |
| -3 | 2 | < 0.1% |
| -2 | 3 | < 0.1% |
| -1 | 13 | < 0.1% |
| 0 | 4171 | |
| 1 | 1596 | 0.8% |
| 2 | 2286 | |
| 3 | 2644 | |
| 4 | 2841 |
| Value | Count | Frequency (%) |
| 154 | 1 | < 0.1% |
| 153 | 1 | < 0.1% |
| 152 | 2 | < 0.1% |
| 150 | 2 | < 0.1% |
| 149 | 1 | < 0.1% |
| 148 | 31 | |
| 147 | 7 | < 0.1% |
| 146 | 29 | |
| 145 | 36 | |
| 144 | 8 | < 0.1% |
total_outstanding_orders
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 281 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 16262 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58.050065 |
| Minimum | -6 |
|---|---|
| Maximum | 285 |
| Zeros | 4111 |
| Zeros (%) | 2.1% |
| Negative | 44 |
| Negative (%) | < 0.1% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | -6 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 17 |
| median | 41 |
| Q3 | 85 |
| 95-th percentile | 169 |
| Maximum | 285 |
| Range | 291 |
| Interquartile range (IQR) | 68 |
Descriptive statistics
| Standard deviation | 52.66183 |
|---|---|
| Coefficient of variation (CV) | 0.90717953 |
| Kurtosis | 0.86124431 |
| Mean | 58.050065 |
| Median Absolute Deviation (MAD) | 29 |
| Skewness | 1.1953218 |
| Sum | 10516698 |
| Variance | 2773.2684 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4111 | 2.1% |
| 9 | 2744 | 1.4% |
| 10 | 2705 | 1.4% |
| 8 | 2685 | 1.4% |
| 6 | 2672 | 1.4% |
| 7 | 2621 | 1.3% |
| 13 | 2618 | 1.3% |
| 11 | 2586 | 1.3% |
| 18 | 2566 | 1.3% |
| 5 | 2559 | 1.3% |
| Other values (271) | 153299 | |
| (Missing) | 16262 | 8.2% |
| Value | Count | Frequency (%) |
| -6 | 5 | < 0.1% |
| -5 | 6 | < 0.1% |
| -4 | 3 | < 0.1% |
| -3 | 8 | < 0.1% |
| -2 | 6 | < 0.1% |
| -1 | 16 | < 0.1% |
| 0 | 4111 | |
| 1 | 1511 | 0.8% |
| 2 | 2079 | |
| 3 | 2334 |
| Value | Count | Frequency (%) |
| 285 | 1 | < 0.1% |
| 283 | 1 | < 0.1% |
| 278 | 20 | |
| 277 | 1 | < 0.1% |
| 276 | 35 | |
| 274 | 14 | < 0.1% |
| 273 | 1 | < 0.1% |
| 272 | 33 | |
| 270 | 19 | |
| 269 | 21 |
estimated_order_place_duration
Real number (ℝ)
| Distinct | 98 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 308.56018 |
| Minimum | 0 |
|---|---|
| Maximum | 2715 |
| Zeros | 94 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 251 |
| Q1 | 251 |
| median | 251 |
| Q3 | 446 |
| 95-th percentile | 446 |
| Maximum | 2715 |
| Range | 2715 |
| Interquartile range (IQR) | 195 |
Descriptive statistics
| Standard deviation | 90.139653 |
|---|---|
| Coefficient of variation (CV) | 0.2921299 |
| Kurtosis | 4.0715872 |
| Mean | 308.56018 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.1440917 |
| Sum | 60918419 |
| Variance | 8125.1571 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 251 | 139013 | |
| 446 | 58221 | |
| 0 | 94 | < 0.1% |
| 1487 | 2 | < 0.1% |
| 642 | 2 | < 0.1% |
| 447 | 2 | < 0.1% |
| 1740 | 2 | < 0.1% |
| 521 | 2 | < 0.1% |
| 303 | 1 | < 0.1% |
| 71 | 1 | < 0.1% |
| Other values (88) | 88 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 94 | |
| 3 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 32 | 1 | < 0.1% |
| 39 | 1 | < 0.1% |
| 53 | 1 | < 0.1% |
| 54 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2715 | 1 | |
| 1740 | 2 | |
| 1676 | 1 | |
| 1673 | 1 | |
| 1642 | 1 | |
| 1623 | 1 | |
| 1553 | 1 | |
| 1487 | 2 | |
| 1431 | 1 | |
| 1310 | 1 |
estimated_store_to_consumer_driving_duration
Real number (ℝ)
| Distinct | 1336 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 526 |
| Missing (%) | 0.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 545.35893 |
| Minimum | 0 |
|---|---|
| Maximum | 2088 |
| Zeros | 9 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 192 |
| Q1 | 382 |
| median | 544 |
| Q3 | 702 |
| 95-th percentile | 909 |
| Maximum | 2088 |
| Range | 2088 |
| Interquartile range (IQR) | 320 |
Descriptive statistics
| Standard deviation | 219.3529 |
|---|---|
| Coefficient of variation (CV) | 0.40221749 |
| Kurtosis | -0.40508768 |
| Mean | 545.35893 |
| Median Absolute Deviation (MAD) | 160 |
| Skewness | 0.1477314 |
| Sum | 1.0738226 × 108 |
| Variance | 48115.696 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 549 | 386 | 0.2% |
| 512 | 385 | 0.2% |
| 590 | 375 | 0.2% |
| 603 | 373 | 0.2% |
| 563 | 368 | 0.2% |
| 556 | 367 | 0.2% |
| 560 | 367 | 0.2% |
| 595 | 362 | 0.2% |
| 547 | 360 | 0.2% |
| 568 | 360 | 0.2% |
| Other values (1326) | 193199 | |
| (Missing) | 526 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 6 | |
| 4 | 3 | < 0.1% |
| 5 | 2 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 2088 | 1 | |
| 1739 | 1 | |
| 1711 | 1 | |
| 1680 | 1 | |
| 1667 | 1 | |
| 1547 | 1 | |
| 1525 | 1 | |
| 1460 | 1 | |
| 1453 | 1 | |
| 1448 | 2 |
| market_id | store_id | order_protocol | total_items | subtotal | num_distinct_items | min_item_price | max_item_price | total_onshift_dashers | total_busy_dashers | total_outstanding_orders | estimated_order_place_duration | estimated_store_to_consumer_driving_duration | store_primary_category | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| market_id | 1.000 | 0.023 | -0.012 | -0.010 | -0.016 | -0.000 | -0.002 | 0.002 | 0.110 | 0.080 | 0.078 | -0.061 | 0.009 | 0.177 |
| store_id | 0.023 | 1.000 | 0.018 | -0.009 | -0.015 | -0.010 | 0.001 | -0.017 | -0.020 | -0.020 | -0.019 | 0.017 | 0.001 | 0.170 |
| order_protocol | -0.012 | 0.018 | 1.000 | -0.010 | -0.073 | -0.025 | -0.045 | -0.097 | 0.161 | 0.164 | 0.154 | -0.708 | -0.008 | 0.319 |
| total_items | -0.010 | -0.009 | -0.010 | 1.000 | 0.664 | 0.917 | -0.591 | -0.007 | 0.057 | 0.053 | 0.059 | -0.001 | 0.018 | 0.021 |
| subtotal | -0.016 | -0.015 | -0.073 | 0.664 | 1.000 | 0.648 | 0.027 | 0.592 | 0.164 | 0.160 | 0.169 | 0.063 | 0.041 | 0.090 |
| num_distinct_items | -0.000 | -0.010 | -0.025 | 0.917 | 0.648 | 1.000 | -0.566 | 0.079 | 0.068 | 0.064 | 0.071 | 0.011 | 0.021 | 0.078 |
| min_item_price | -0.002 | 0.001 | -0.045 | -0.591 | 0.027 | -0.566 | 1.000 | 0.430 | 0.055 | 0.056 | 0.057 | 0.056 | 0.003 | 0.106 |
| max_item_price | 0.002 | -0.017 | -0.097 | -0.007 | 0.592 | 0.079 | 0.430 | 1.000 | 0.168 | 0.165 | 0.173 | 0.087 | 0.024 | 0.158 |
| total_onshift_dashers | 0.110 | -0.020 | 0.161 | 0.057 | 0.164 | 0.068 | 0.055 | 0.168 | 1.000 | 0.966 | 0.957 | -0.210 | 0.052 | 0.099 |
| total_busy_dashers | 0.080 | -0.020 | 0.164 | 0.053 | 0.160 | 0.064 | 0.056 | 0.165 | 0.966 | 1.000 | 0.962 | -0.212 | 0.050 | 0.096 |
| total_outstanding_orders | 0.078 | -0.019 | 0.154 | 0.059 | 0.169 | 0.071 | 0.057 | 0.173 | 0.957 | 0.962 | 1.000 | -0.203 | 0.049 | 0.091 |
| estimated_order_place_duration | -0.061 | 0.017 | -0.708 | -0.001 | 0.063 | 0.011 | 0.056 | 0.087 | -0.210 | -0.212 | -0.203 | 1.000 | -0.024 | 0.100 |
| estimated_store_to_consumer_driving_duration | 0.009 | 0.001 | -0.008 | 0.018 | 0.041 | 0.021 | 0.003 | 0.024 | 0.052 | 0.050 | 0.049 | -0.024 | 1.000 | 0.038 |
| store_primary_category | 0.177 | 0.170 | 0.319 | 0.021 | 0.090 | 0.078 | 0.106 | 0.158 | 0.099 | 0.096 | 0.091 | 0.100 | 0.038 | 1.000 |
| market_id | created_at | actual_delivery_time | store_id | store_primary_category | order_protocol | total_items | subtotal | num_distinct_items | min_item_price | max_item_price | total_onshift_dashers | total_busy_dashers | total_outstanding_orders | estimated_order_place_duration | estimated_store_to_consumer_driving_duration | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | 2015-02-06 22:24:17 | 2015-02-06 23:27:16 | 1845 | american | 1.0 | 4 | 3441 | 4 | 557 | 1239 | 33.0 | 14.0 | 21.0 | 446 | 861.0 |
| 1 | 2.0 | 2015-02-10 21:49:25 | 2015-02-10 22:56:29 | 5477 | mexican | 2.0 | 1 | 1900 | 1 | 1400 | 1400 | 1.0 | 2.0 | 2.0 | 446 | 690.0 |
| 2 | 3.0 | 2015-01-22 20:39:28 | 2015-01-22 21:09:09 | 5477 | NaN | 1.0 | 1 | 1900 | 1 | 1900 | 1900 | 1.0 | 0.0 | 0.0 | 446 | 690.0 |
| 3 | 3.0 | 2015-02-03 21:21:45 | 2015-02-03 22:13:00 | 5477 | NaN | 1.0 | 6 | 6900 | 5 | 600 | 1800 | 1.0 | 1.0 | 2.0 | 446 | 289.0 |
| 4 | 3.0 | 2015-02-15 02:40:36 | 2015-02-15 03:20:26 | 5477 | NaN | 1.0 | 3 | 3900 | 3 | 1100 | 1600 | 6.0 | 6.0 | 9.0 | 446 | 650.0 |
| 5 | 3.0 | 2015-01-28 20:30:38 | 2015-01-28 21:08:58 | 5477 | NaN | 1.0 | 3 | 5000 | 3 | 1500 | 1900 | 2.0 | 2.0 | 2.0 | 446 | 338.0 |
| 6 | 3.0 | 2015-01-31 02:16:36 | 2015-01-31 02:43:00 | 5477 | NaN | 1.0 | 2 | 3900 | 2 | 1200 | 2700 | 10.0 | 9.0 | 9.0 | 446 | 638.0 |
| 7 | 3.0 | 2015-02-12 03:03:35 | 2015-02-12 03:36:20 | 5477 | NaN | 1.0 | 4 | 4850 | 4 | 750 | 1800 | 7.0 | 8.0 | 7.0 | 446 | 626.0 |
| 8 | 2.0 | 2015-02-16 00:11:35 | 2015-02-16 00:38:01 | 5477 | indian | 3.0 | 4 | 4771 | 3 | 820 | 1604 | 8.0 | 6.0 | 18.0 | 446 | 289.0 |
| 9 | 3.0 | 2015-02-18 01:15:45 | 2015-02-18 02:08:57 | 5477 | NaN | 1.0 | 2 | 2100 | 2 | 700 | 1200 | 2.0 | 2.0 | 2.0 | 446 | 715.0 |
| market_id | created_at | actual_delivery_time | store_id | store_primary_category | order_protocol | total_items | subtotal | num_distinct_items | min_item_price | max_item_price | total_onshift_dashers | total_busy_dashers | total_outstanding_orders | estimated_order_place_duration | estimated_store_to_consumer_driving_duration | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 197418 | 1.0 | 2015-01-30 20:50:23 | 2015-01-30 22:24:38 | 2956 | fast | 4.0 | 2 | 1528 | 2 | 639 | 729 | 26.0 | 29.0 | 34.0 | 251 | 791.0 |
| 197419 | 1.0 | 2015-01-26 21:25:12 | 2015-01-26 22:21:22 | 2956 | fast | 4.0 | 1 | 809 | 1 | 729 | 729 | 20.0 | 18.0 | 18.0 | 251 | 818.0 |
| 197420 | 2.0 | 2015-02-18 02:16:04 | 2015-02-18 03:12:36 | 2956 | indian | 3.0 | 3 | 2352 | 3 | 499 | 685 | 49.0 | 49.0 | 65.0 | 251 | 560.0 |
| 197421 | 1.0 | 2015-01-30 03:35:01 | 2015-01-30 04:42:19 | 2956 | fast | 4.0 | 2 | 979 | 2 | 145 | 339 | NaN | NaN | NaN | 251 | 614.0 |
| 197422 | 1.0 | 2015-01-31 19:48:15 | 2015-01-31 20:27:39 | 2956 | fast | 4.0 | 7 | 2445 | 3 | 145 | 585 | 23.0 | 24.0 | 24.0 | 251 | 608.0 |
| 197423 | 1.0 | 2015-02-17 00:19:41 | 2015-02-17 01:24:48 | 2956 | fast | 4.0 | 3 | 1389 | 3 | 345 | 649 | 17.0 | 17.0 | 23.0 | 251 | 331.0 |
| 197424 | 1.0 | 2015-02-13 00:01:59 | 2015-02-13 00:58:22 | 2956 | fast | 4.0 | 6 | 3010 | 4 | 405 | 825 | 12.0 | 11.0 | 14.0 | 251 | 915.0 |
| 197425 | 1.0 | 2015-01-24 04:46:08 | 2015-01-24 05:36:16 | 2956 | fast | 4.0 | 5 | 1836 | 3 | 300 | 399 | 39.0 | 41.0 | 40.0 | 251 | 795.0 |
| 197426 | 1.0 | 2015-02-01 18:18:15 | 2015-02-01 19:23:22 | 3630 | sandwich | 1.0 | 1 | 1175 | 1 | 535 | 535 | 7.0 | 7.0 | 12.0 | 446 | 384.0 |
| 197427 | 1.0 | 2015-02-08 19:24:33 | 2015-02-08 20:01:41 | 3630 | sandwich | 1.0 | 4 | 2605 | 4 | 425 | 750 | 20.0 | 20.0 | 23.0 | 446 | 134.0 |